UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4bAFsK77zyXT5jO3wW0zOWSLgD+IkTfJAGy48k5xbes='
WHERE
key_id = 'c6e7e25f7add97752f22b3ffe3e9b74ef2d60852d264b65919bd9f98e3c00dcf'
AND (
token = '4bAFsK77zyXT5jO3wW0zOWSLgD+IkTfJAGy48k5xbes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)