UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xIkMAasU5RkelXWAOQ2czgVgoWjiLTLGv5gtfYgXjMA='
WHERE
key_id = 'bac1698929804e91cae3490ffea75ce55fad59215166756340cfd5471caa51a9'
AND (
token = 'xIkMAasU5RkelXWAOQ2czgVgoWjiLTLGv5gtfYgXjMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)