UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xwwe+QBwvuT5Wa7RuKqc8jnSaPQaJAod6yXNLEY8R+E='
WHERE
key_id = 'c7d111c71e3878499c3dd18067eb9ab8d596c9bdcf48db1bdf7160c79fab04c0'
AND (
token = 'Xwwe+QBwvuT5Wa7RuKqc8jnSaPQaJAod6yXNLEY8R+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)