UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0HLQ+OgrD5ob6wZgB058bV10X6GZqeC1bEpi1R6l3ho='
WHERE
key_id = '0cc4164af8773082bd7e94ce7daed6543cc47d0a5fac9a9998c9c2e014356ae5'
AND (
token = '0HLQ+OgrD5ob6wZgB058bV10X6GZqeC1bEpi1R6l3ho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)