UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XicdLfi9znvG20EtQvQPpcigN3Tqydaov5U7Zg3zWZY='
WHERE
key_id = '0728279827f867ecc1e547fdcc18425de676a0506961a73b4b95b677e0b3bffb'
AND (
token = 'XicdLfi9znvG20EtQvQPpcigN3Tqydaov5U7Zg3zWZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)