UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kho8NuGC0HJs1VRlD8YqtIQhYAJ3Kvjxe8Vj5lsz4Bo='
WHERE
key_id = 'bd55a16e21703714f993307885bd9d85bcbebd9912343a058870d5df11989101'
AND (
token = 'kho8NuGC0HJs1VRlD8YqtIQhYAJ3Kvjxe8Vj5lsz4Bo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)