UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E9lwsJH8r6Fub32R+eJz7fCxP05a1yPhzToNo87YURs='
WHERE
key_id = '9b72dfc9d55d2721b3aeb598ed02baf60ac7801566264dd2e11ab44fc5e05304'
AND (
token = 'E9lwsJH8r6Fub32R+eJz7fCxP05a1yPhzToNo87YURs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)