UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gETeF2oFzNfZtUbbTTw4lcBvkqyM1vOVP9Ls0cDrdA='
WHERE
key_id = '8b51720fba058813ece7e16c56f12515d0f51edab3547f016d99f817e38b9443'
AND (
token = '6gETeF2oFzNfZtUbbTTw4lcBvkqyM1vOVP9Ls0cDrdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)