UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yBOcLKlHi1zOyrzx30ptg5UwO+C676mFIYQi/G10M6E='
WHERE
key_id = '3df62bd071598948818273c4e03dea4cce79170b7d51c02cacb813daae0603bb'
AND (
token = 'yBOcLKlHi1zOyrzx30ptg5UwO+C676mFIYQi/G10M6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)