UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oX+aBUCzCSSd5pUfcCmn58GOIiqqebF02YtntxROmw0='
WHERE
key_id = 'ad4aaa665af6b5e29352d44e8a33ef77396c285631144d126b26536d323ce8f1'
AND (
token = 'oX+aBUCzCSSd5pUfcCmn58GOIiqqebF02YtntxROmw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)