UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3kQPu5lvt55I77d7NXxCtL2X9M7T9jUGltU2571cKVI='
WHERE
key_id = 'b6499a5f9ed1fab83de43ba2bd8ecd8bb2aeff0cc1d4748cb4ee06b98de037d7'
AND (
token = '3kQPu5lvt55I77d7NXxCtL2X9M7T9jUGltU2571cKVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)