UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/tlsOc9NOThoBM3wCf3zjXC6qKIGAI7JEPYbEU8Or7k='
WHERE
key_id = '0b6041f40d3928a80cc9d75554774a02ba63a1bdead13964a69fafcb227b2a1c'
AND (
token = '/tlsOc9NOThoBM3wCf3zjXC6qKIGAI7JEPYbEU8Or7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)