UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3T9nF/wq4BdARHIZaElVFgyFEmyiQvhFKw/EZT9U7yk='
WHERE
key_id = 'f8d2c6d4978116ac663587539a04687ec4e0bd5699815070c59744264fb98dc5'
AND (
token = '3T9nF/wq4BdARHIZaElVFgyFEmyiQvhFKw/EZT9U7yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)