UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D8CmOfo95HBKC6EXVDnc6hVg+uR6j2kKGsgFp41hXME='
WHERE
key_id = '9b2e779e8d6c8ee2e42ccab91f2bf4826a0a627b4e00fcc4a72d4e222b1363eb'
AND (
token = 'D8CmOfo95HBKC6EXVDnc6hVg+uR6j2kKGsgFp41hXME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)