UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zWpei33NHhIxR264VVpLV/6SbHTOdvPGs2L2RK7B1pw='
WHERE
key_id = 'cd923ffa6679ce3fad889221658bf3e4a4ee5e3af9bc9743f69787d5100b5d89'
AND (
token = 'zWpei33NHhIxR264VVpLV/6SbHTOdvPGs2L2RK7B1pw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)