UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8iLGMYN13FxL0KK5AIT7yFbr/VWNFtzGmypsURSdApk='
WHERE
key_id = '3a8eef276b7ce355ed05da5973bf86eda22a70f0d778028d271d8d01488aba99'
AND (
token = '8iLGMYN13FxL0KK5AIT7yFbr/VWNFtzGmypsURSdApk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)