UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gI5PwPnYHsWl0vkrmzysG6kM6aVsDepw1MSITCohb4A='
WHERE
key_id = '93f8122dd4c1c210b5eb145afad81073607198d5a87ec0befcd667f504f8999d'
AND (
token = 'gI5PwPnYHsWl0vkrmzysG6kM6aVsDepw1MSITCohb4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)