UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y3qdxWuAqpj19V1dnOd2DdOZBgbz7pVei+2D5kCt9GQ='
WHERE
key_id = 'b7fd1caa03400147d51abccb962bad01fd30e0d8f1cdc1db336657a78798513a'
AND (
token = 'Y3qdxWuAqpj19V1dnOd2DdOZBgbz7pVei+2D5kCt9GQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)