UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QZpnvfhB3oRe5z8RCrlcBeA4iOaEwaLofbnOuauUN/k='
WHERE
key_id = '456dae1b30468501e864ddf22354803e4f7336a6fe7aa464e26add2de6ca1168'
AND (
token = 'QZpnvfhB3oRe5z8RCrlcBeA4iOaEwaLofbnOuauUN/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)