UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H3R6ITuXJnXV5ndXRukbYKGBK4kpTHuG4mxpbOa/riE='
WHERE
key_id = 'd49cbf28e31915bf74cf538791ae2868323172ef10615102dc6d7cb0724e1b38'
AND (
token = 'H3R6ITuXJnXV5ndXRukbYKGBK4kpTHuG4mxpbOa/riE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)