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