UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bwUSkcKQvcF9lrjPLnUO9O+mRH9+KQPud1cAz+3adgc='
WHERE
key_id = 'd9fcff2ce329e45226eb8151ad68342c71279713e32480fea28b48430ccf8a84'
AND (
token = 'bwUSkcKQvcF9lrjPLnUO9O+mRH9+KQPud1cAz+3adgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)