UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8BPFTS9VdU+grQzkUHABMj0lbJ1vRJZcfXBJX6EW8Bw='
WHERE
key_id = '93b5697661c09052004b32e98df130c96860ece9b21a3d2ec4b833bee1611f22'
AND (
token = '8BPFTS9VdU+grQzkUHABMj0lbJ1vRJZcfXBJX6EW8Bw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)