UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gTUq7XvFbfUi5qAc8kpDs6L8l4tOvOtIb9Al2bPvoSg='
WHERE
key_id = '0f1cc8e1c7323fad9f0c4bfd43fc8736cdf2aff68754d6c7d1dfc33f98a7a2e6'
AND (
token = 'gTUq7XvFbfUi5qAc8kpDs6L8l4tOvOtIb9Al2bPvoSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)