UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X/TPcp0Ju8AjC2LEQzGCxoHPRButDV58CXgPWFZJH0E='
WHERE
key_id = 'a38ebd55db9898ba2256263047723beb276315fb6b7e78ea7cc1300fb24851e8'
AND (
token = 'X/TPcp0Ju8AjC2LEQzGCxoHPRButDV58CXgPWFZJH0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)