UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xto01rDwHFat91i5ZPOnOnnkL1zROGWw2Xlmhs0MtRE='
WHERE
key_id = 'e1ea7cb63982df5bac636587e35511aeb5cd49ae480240afe6cada31f6961a9e'
AND (
token = 'xto01rDwHFat91i5ZPOnOnnkL1zROGWw2Xlmhs0MtRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)