UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YPl8Xov9iFu28Red31UuYcnE0NRgx0ujm+43QvO/mww='
WHERE
key_id = 'a7de3474817aa25e76163ed3ac2907fa62da56bfafce5d0bcc2512974c2b4cd4'
AND (
token = 'YPl8Xov9iFu28Red31UuYcnE0NRgx0ujm+43QvO/mww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)