UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0UZYCoeAIKJGmraqobhfMvZO10f+6paV7wT8c3jPoh8='
WHERE
key_id = 'b2c8b3566c0838ecf0ff3f6f5baa4b9d6306ad77975e5bae72e22153b191ef32'
AND (
token = '0UZYCoeAIKJGmraqobhfMvZO10f+6paV7wT8c3jPoh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)