UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3P8xF7O8ssZfD4EF8V+0yhJArwJtKdAFG/0lPz/fmrI='
WHERE
key_id = '9d64829b9e8057467740f5cef54aaa9db242d9fc9ba45f339c500ac19e927239'
AND (
token = '3P8xF7O8ssZfD4EF8V+0yhJArwJtKdAFG/0lPz/fmrI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)