UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GBL9+yjcgrsKyPN4VNG4q73Le6SURpy/HFxFDoqwV8='
WHERE
key_id = 'ddf0201a9f465ea488c9c7b9392d161ffa33a9442ad87b777a33de072db24a92'
AND (
token = '6GBL9+yjcgrsKyPN4VNG4q73Le6SURpy/HFxFDoqwV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)