UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oATWDwuk3IV4yGJClxqdVhAClA+5ayDkiGG+dWmVkLg='
WHERE
key_id = '9278a8c9068ce9b9e0cb5544c584e90f196c0b0021da2785e13466f126b6d39f'
AND (
token = 'oATWDwuk3IV4yGJClxqdVhAClA+5ayDkiGG+dWmVkLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)