UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Knl6v0u+tmZPcDcmuWZgvR2PRRdv8kfSsAAJPpksd8='
WHERE
key_id = '98ff6ba4175c880bb107cea78ebee5ad1d933b36394e261c03967deaa0670804'
AND (
token = '1Knl6v0u+tmZPcDcmuWZgvR2PRRdv8kfSsAAJPpksd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)