UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rmX4SrjqxLT3p+TfWPFw3X+vCztr9ZVQyMzUyXwSNak='
WHERE
key_id = '0ab4c4755e3c32a1ae1f9ce7f1ca9e7e0a3e7dd5250be0a253e00262c15efa02'
AND (
token = 'rmX4SrjqxLT3p+TfWPFw3X+vCztr9ZVQyMzUyXwSNak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)