UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9GB44if3TNbs+C+7S+XHx4YHUdMqn4piHKSoeiIPHoA='
WHERE
key_id = '89339f0ed54930d0bc4833173fe29ee636fa591a5876b8ab1a294996ad8e0f0a'
AND (
token = '9GB44if3TNbs+C+7S+XHx4YHUdMqn4piHKSoeiIPHoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)