UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PdmEH9x0rT9wLA8yJqLjyeC+W852QUiS/015Dt2iK+k='
WHERE
key_id = '9b12dcecc42044d2395636ccb5fb94ffca199b6f46a497e0a290913ba18c7bbb'
AND (
token = 'PdmEH9x0rT9wLA8yJqLjyeC+W852QUiS/015Dt2iK+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)