UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'imS1kvtIQRAIwu71FqTeIW1+I/GNjB91hIYZg+yZr5o='
WHERE
key_id = '057eae8359550b07deab4615957d01520473e560e34d68596bf38b8cedf79c30'
AND (
token = 'imS1kvtIQRAIwu71FqTeIW1+I/GNjB91hIYZg+yZr5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)