UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ABBCIutX2DZJjU9MZesOpk+SWSQ/uc4OqX/icw7cyU='
WHERE
key_id = 'b696ee9dfa7439bfdc489534ce294f9392f6e9dbfaa3056d23c258ad2164bb20'
AND (
token = '0ABBCIutX2DZJjU9MZesOpk+SWSQ/uc4OqX/icw7cyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)