UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7OB+hco4auhCdvhccx3yPgjhxOPrmbny7nK4PbHmv0='
WHERE
key_id = '7198837b2cf5911261bca1fb4d9967256c51ce5b2de207e4cf449a4106e0863e'
AND (
token = 'a7OB+hco4auhCdvhccx3yPgjhxOPrmbny7nK4PbHmv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)