UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2MZOmLLJA7Igo97bbqtce3e4Cb3dUjmPQ68T2xRgf+0='
WHERE
key_id = '47ddfa7a0c34fbf04a7aae92e49b58f27d6c7c7209db8bb111b3810bde14c7ee'
AND (
token = '2MZOmLLJA7Igo97bbqtce3e4Cb3dUjmPQ68T2xRgf+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)