UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Gr1DCHZbQxAOl1xQidIyaHdfDhPz4WWiEiuMh9N3PA='
WHERE
key_id = 'a12f88aed520be4987682bde8529fc7d0adba889ceae86795ffc7be33ba26132'
AND (
token = '9Gr1DCHZbQxAOl1xQidIyaHdfDhPz4WWiEiuMh9N3PA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)