UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8wOvdi71MCVWAxbNvpzNBNwgkP2Ft03dxL4eALTuY+g='
WHERE
key_id = 'f6e203cbda0d91ddf0b5ec3d6f98959fe782856e0f287bacab2ffc6cfbe7a67c'
AND (
token = '8wOvdi71MCVWAxbNvpzNBNwgkP2Ft03dxL4eALTuY+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)