UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Kxaeo7i4qCYdYKi77bq/vubbrziM+Ja2dw3G19A9og='
WHERE
key_id = 'c2422811d10f884e24b63b63bfdcb6473d7d4450c6d3f4ed8921fe311f6505a9'
AND (
token = '7Kxaeo7i4qCYdYKi77bq/vubbrziM+Ja2dw3G19A9og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)