UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ho4Wpn7u6k7LggXnGzZNFksRLvQqree8VFPjrE0UwdM='
WHERE
key_id = '47a4a75d56d56cb837bcf43a54aa3df030868cae55c787fe3649b6e0aba72a3c'
AND (
token = 'ho4Wpn7u6k7LggXnGzZNFksRLvQqree8VFPjrE0UwdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)