UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AbHx936MBVYuL+LGbxgmDHKSkGXwbEszoSp8CAQCBTU='
WHERE
key_id = '38caee31b596061532cd012a6bf7c8001d44ccfd04cc6dc24173bf6fcb768f2a'
AND (
token = 'AbHx936MBVYuL+LGbxgmDHKSkGXwbEszoSp8CAQCBTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)