UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'crCQQioI/t54F0eZRuRlPZmhtoU6aQK3IJLxtAOu+Kw='
WHERE
key_id = '505c6422751b2cd430a2cc1e49b5bcdb51c7e9fa894df17fc91a0776a9f43331'
AND (
token = 'crCQQioI/t54F0eZRuRlPZmhtoU6aQK3IJLxtAOu+Kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)